<?php

/***********************************************/
/*CONTENIDO*/
/***********************************************/
echo" <div class=\"pag_content\">
 	<div class=\"pag_content_title\">
		<div class=\"pag_title_cap\">Cap&iacute;tulo 1: </div>
		<div class=\"pag_title_cont\">Utilizar RMAN</div>
    </div>
    <div class=\"pag_content_body\">         
	<div class=\"contenido_principal\">	
		<br />";
		
/***********************************************/
/*TITULO PARTE*/
/***********************************************/

echo"	<div class=\"parrafo_titulo\">
		Historico backups
	</div>";		

	
/***********************************************/
/*CONTENIDO*/
/***********************************************/

echo"
 <div class=\"parrafo\" align=\"justify\">
LIST muestra la informacion de los backups que hemos hecho de nuestra base de datos. Podemos configurarlo con los parametros BY BACKUP  y BY FILE. Tambien para configurar la cantidad de informacion que se va a mostrar podemos utilizar RESUME o VERBOSE.
</div>
<div class=\"parrafo\" align=\"justify\">
Ejemplos:
</div>
<blockquote style=\"COLOR: #2e5348; FONT-SIZE: 12px; FONT-WEIGHT: bold FONT:Arial, Helvetica, sans-serif\">
<pre><p>RMAN&GT;LIST BACKUPSET BY BACKUP RESUME;

List of Backups
===============
Key 	TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
46  	B  F  A DISK    	26-FEB-11   	1   	1   	NO     	MONTHLY_BACKUP
47  	B  F  A DISK    	26-FEB-11   	1   	1   	NO     	MONTHLY_BACKUP
168 	B  F  A DISK    	03-MAR-11   	1   	1   	NO     	TAG20110303T171428
212 	B  F  A DISK    	03-MAR-11   	1   	1   	NO     	TAG20110303T182538
223 	B  F  A DISK    	03-MAR-11   	1   	1   	NO     	BACKUP_USERS

</p></pre></blockquote>
<div class=\"parrafo\" align=\"justify\">
Utilizando BY FILE te muestra los backups que se han realizado diferenciando por los diferentes ficheros, 
</div>
<blockquote style=\"COLOR: #2e5348; FONT-SIZE: 12px; FONT-WEIGHT: bold FONT:Arial, Helvetica, sans-serif\">
<pre><p>RMAN&GT; LIST BACKUPSET BY FILE;

List of Datafile Backups
========================

File Key 	TY LV S Ckp SCN	Ckp Time  #Pieces #Copies Compressed Tag
---- ------- -  -- - ---------- --------- ------- ------- ---------- ---
1	168 	B  F  A 619133 	03-MAR-11 1   	1   	NO     	TAG20110303T171428
 	46  	B  F  A 591428 	26-FEB-11 1   	1   	NO     	MONTHLY_BACKUP
2	340 	B  F  A 626940 	03-MAR-11 3   	1   	NO     	TAG20110303T212842
 	168 	B  F  A 619133 	03-MAR-11 1   	1   	NO     	TAG20110303T171428


List of Archived Log Backups
============================

Thrd Seq 	Low SCN	Low Time  BS Key  S #Pieces #Copies Compressed Tag
---- ------- ---------- --------- ------- - ------- ------- ---------- ---
1	1   	446075 	29-JAN-11 318 	A 1   	1   	NO     	TAG20110303T212620
1	2   	475046 	29-JAN-11 318 	A 1   	1   	NO     	TAG20110303T212620
1	3   	510048 	09-FEB-11 318 	A 1   	1   	NO     	TAG20110303T212620

List of Control File Backups
============================

CF Ckp SCN Ckp Time  BS Key  S #Pieces #Copies Compressed Tag
---------- --------- ------- - ------- ------- ---------- ---
626954 	03-MAR-11 342 	A 1   	1   	NO     	TAG20110303T212842
626646 	03-MAR-11 263 	A 1   	1   	NO     	TAG20110303T211615
591486 	26-FEB-11 47  	A 1   	1   	NO     	MONTHLY_BACKUP
List of SPFILE Backups
======================

Modification Time BS Key  S #Pieces #Copies Compressed Tag
----------------- ------- - ------- ------- ---------- ---
03-MAR-11     	343 	A 1   	1   	NO     	TAG20110303T212842
03-MAR-11     	262 	A 1   	1   	NO     	TAG20110303T211615
26-FEB-11     	47  	A 1   	1   	NO     	MONTHLY_BACKUP

</p></pre></blockquote>
<div class=\"parrafo\" align=\"justify\">
REPORT. Este comando pregunta a RMAN que ficheros necesitan un backup, o no lo necesitan, muestra informacion de los operaciones de recuperacion que ha tenido que hacer RMAN.
</div>
<blockquote style=\"COLOR: #2e5348; FONT-SIZE: 12px; FONT-WEIGHT: bold FONT:Arial, Helvetica, sans-serif\">
<pre><p>RMAN&GT; REPORT OBSOLETE;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type             	Key	Completion Time	Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 	40 	29-JAN-11      	+GROUP1/orcl/controlfile/control01.ctl
Backup Set       	46 	26-FEB-11
  Backup Piece   	50 	26-FEB-11      	/home/oracle/oracle/product/10.2.0/db_1/dbs/db_04m5l34e_ORCL_4
Datafile Copy    	73 	02-MAR-11      	/tmp/users.dbf
Backup Set       	47 	26-FEB-11
  Backup Piece   	51 	26-FEB-11      	/home/oracle/oracle/product/10.2.0/db_1/dbs/db_05m5l39s_ORCL_5
Control File Copy 	74 	02-MAR-11      	/tmp/control001.ctl
Backup Set       	212	03-MAR-11
  Backup Piece   	215	03-MAR-11      	/home/oracle/oracle/product/10.2.0/db_1/dbs/users_ts_ORCL117
Backup Set       	223	03-MAR-11
  Backup Piece   	225	03-MAR-11      	/home/oracle/oracle/product/10.2.0/db_1/dbs/users_ts_ORCL_1_18
  
</p></pre></blockquote>
<div class=\"parrafo\" align=\"justify\">
Con este comando le hemos preguntado a RMAN que backups estan obsoletos, que no se necestaran en el futuro.
</div>
<div class=\"parrafo\" align=\"justify\">
Tambien podemos utilizar REPORT para mostrar la estructura de nuestra base de datos.
</div>




";
	
echo"
	</div> 		 
    </div>
    <div class=\"pag_content_footer\">
    </div>
    <div class=\"pag_content_nav\">		
		<div class=\"pag_contenido_left\">
			<a  class=\"cap_next\" href=\"ocp_main.php?cap=2&part=4\">	&lt; Anterior </a>
		 </div>
		<div class=\"pag_contenido_right\" align=\"right\">	
			<a  class=\"cap_next\" href=\"ocp_main.php?cap=3&part=0\">	Cap&iacute;tulo 3 &gt;</a>
		 </div>
	</div>      
</div>
";


?>